/* Important: you need to put the .dat and .do files in one folder/
   directory and then set the working folder to that folder. */

clear
set more off
set mem 800m
cd E:\MarchCPS\

infix ///
 int     year          1-4 ///
 long    serial        5-9 ///
 byte    mish         10 ///
 byte    statefip     11-12 ///
 long    hhincome     13-18 ///
 byte    pernum       19-20 ///
 /*float*/ earnwt       21-28 ///
 byte    momloc       29-30 ///
 byte    stepmom      31 ///
 byte    momrule      32 ///
 byte    poploc       33-34 ///
 byte    steppop      35 ///
 byte    poprule      36 ///
 byte    sploc        37-38 ///
 byte    sprule       39 ///
 byte    nchild       40 ///
 byte    eldch        41-42 ///
 byte    yngch        43-44 ///
 int     relate       45-48 ///
 byte    age          49-50 ///
 byte    sex          51 ///
 int     race         52-54 ///
 byte    marst        55 ///
 int     hispan       56-58 ///
 byte    educrec      59-60 ///
 byte    empstat      61-62 ///
 int     occ1950      63-65 ///
 int     ind1950      66-68 ///
 byte    classwkr     69-70 ///
 byte    wkswork1     71-72 ///
 byte    hrswork      73-74 ///
 byte    uhrswork     75-76 ///
 long    incwage      77-82 ///
 int     earnweek     83-86 ///
 long    adjginc      87-91 ///
 using "March CPS Extract.dat"

generate earnwtd=earnwt/100

label var year "Survey year"
label var serial "Household serial number"
label var mish "Month in sample, household level"
label var statefip "State (FIPS code)"
label var hhincome "Total household income"
label var pernum "Person number in sample unit"
label var earnwt "Earnings weight"
label var momloc "Mother's location in the household"
label var stepmom "Probable step/adopted mother"
label var momrule "Rule for linking mother"
label var poploc "Father's location in the household"
label var steppop "Probable step/adopted father"
label var poprule "Rule for linking father"
label var sploc "Spouse's location in household"
label var sprule "Rule for linking spouse"
label var nchild "Number of own children in household"
label var eldch "Age of eldest own child in household"
label var yngch "Age of youngest own child in household"
label var relate "Relationship to household head"
label var age "Age"
label var sex "Sex"
label var race "Race"
label var marst "Marital status"
label var hispan "Hispanic origin"
label var educrec "Educational attainment recode"
label var empstat "Employment status"
label var occ1950 "Occupation, 1950 basis"
label var ind1950 "Industry, 1950 basis"
label var classwkr "Class of worker"
label var wkswork1 "Weeks worked last year"
label var hrswork "Hours worked last week"
label var uhrswork "Usual hours worked per week (last yr)"
label var incwage "Wage and salary income"
label var earnweek "Weekly earnings"
label var adjginc "Adjusted gross income"

label values year yearlbl

label values serial seriallbl

label define mishlbl 1 "One"
label define mishlbl 2 "Two", add
label define mishlbl 3 "Three", add
label define mishlbl 4 "Four", add
label define mishlbl 5 "Five", add
label define mishlbl 6 "Six", add
label define mishlbl 7 "Seven", add
label define mishlbl 8 "Eight", add
label values mish mishlbl

label define statefiplbl 01 "Alabama"
label define statefiplbl 02 "Alaska", add
label define statefiplbl 04 "Arizona", add
label define statefiplbl 05 "Arkansas", add
label define statefiplbl 06 "California", add
label define statefiplbl 08 "Colorado", add
label define statefiplbl 09 "Connecticut", add
label define statefiplbl 10 "Delaware", add
label define statefiplbl 11 "District of Columbia", add
label define statefiplbl 12 "Florida", add
label define statefiplbl 13 "Georgia", add
label define statefiplbl 15 "Hawaii", add
label define statefiplbl 16 "Idaho", add
label define statefiplbl 17 "Illinois", add
label define statefiplbl 18 "Indiana", add
label define statefiplbl 19 "Iowa", add
label define statefiplbl 20 "Kansas", add
label define statefiplbl 21 "Kentucky", add
label define statefiplbl 22 "Louisiana", add
label define statefiplbl 23 "Maine", add
label define statefiplbl 24 "Maryland", add
label define statefiplbl 25 "Massachusetts", add
label define statefiplbl 26 "Michigan", add
label define statefiplbl 27 "Minnesota", add
label define statefiplbl 28 "Mississippi", add
label define statefiplbl 29 "Missouri", add
label define statefiplbl 30 "Montana", add
label define statefiplbl 31 "Nebraska", add
label define statefiplbl 32 "Nevada", add
label define statefiplbl 33 "New Hampshire", add
label define statefiplbl 34 "New Jersey", add
label define statefiplbl 35 "New Mexico", add
label define statefiplbl 36 "New York", add
label define statefiplbl 37 "North Carolina", add
label define statefiplbl 38 "North Dakota", add
label define statefiplbl 39 "Ohio", add
label define statefiplbl 40 "Oklahoma", add
label define statefiplbl 41 "Oregon", add
label define statefiplbl 42 "Pennsylvania", add
label define statefiplbl 44 "Rhode Island", add
label define statefiplbl 45 "South Carolina", add
label define statefiplbl 46 "South Dakota", add
label define statefiplbl 47 "Tennessee", add
label define statefiplbl 48 "Texas", add
label define statefiplbl 49 "Utah", add
label define statefiplbl 50 "Vermont", add
label define statefiplbl 51 "Virginia", add
label define statefiplbl 53 "Washington", add
label define statefiplbl 54 "West Virginia", add
label define statefiplbl 55 "Wisconsin", add
label define statefiplbl 56 "Wyoming", add
label define statefiplbl 61 "Maine-New Hampshire-Vermont", add
label define statefiplbl 65 "Montana-Idaho-Wyoming", add
label define statefiplbl 68 "Alaska-Hawaii", add
label define statefiplbl 69 "Nebraska-North Dakota-South Dakota", add
label define statefiplbl 70 "Maine-Massachusetts-New Hampshire-Rhode Island-Vermont", add
label define statefiplbl 71 "Michigan-Wisconsin", add
label define statefiplbl 72 "Minnesota-Iowa", add
label define statefiplbl 73 "Nebraska-North Dakota-South Dakota-Kansas", add
label define statefiplbl 74 "Delaware-Virginia", add
label define statefiplbl 75 "North Carolina-South Carolina", add
label define statefiplbl 76 "Alabama-Mississippi", add
label define statefiplbl 77 "Arkansas-Oklahoma", add
label define statefiplbl 78 "Arizona-New Mexico-Colorado", add
label define statefiplbl 79 "Idaho-Wyoming-Utah-Montana-Nevada", add
label define statefiplbl 80 "Alaska-Washington-Hawaii", add
label define statefiplbl 81 "New Hampshire-Maine-Vermont-Rhode Island", add
label define statefiplbl 83 "South Carolina-Georgia", add
label define statefiplbl 84 "Kentucky-Tennessee", add
label define statefiplbl 85 "Arkansas-Louisiana-Oklahoma", add
label define statefiplbl 86 "Montana-Idaho-Wyoming-Colorado-New Mexico-Utah-Nevada", add
label define statefiplbl 87 "Iowa-N Dakota-S Dakota-Nebraska-Kansas-Minnesota-Missouri", add
label define statefiplbl 88 "Washington-Oregon-Alaska-Hawaii", add
label define statefiplbl 89 "Montana-Wyoming-Colorado-New Mexico-Utah-Nevada-Arizona", add
label define statefiplbl 90 "Delaware-Maryland-Virginia-West Virginia", add
label define statefiplbl 99 "State not identified", add
label values statefip statefiplbl

label values hhincome hhincomelbl

label values pernum pernumlbl

label values earnwt earnwtlbl

label values momloc momloclbl

label define stepmomlbl 0 "No stepmother present"
label define stepmomlbl 1 "Improbable age difference", add
label define stepmomlbl 2 "Spouse of father", add
label define stepmomlbl 3 "Identified stepmother", add
label values stepmom stepmomlbl

label define momrulelbl 0 "No mother link"
label define momrulelbl 1 "Unambiguous mother link", add
label define momrulelbl 2 "Daughter/grandchild link", add
label define momrulelbl 3 "Preceding female (no intervening person)", add
label define momrulelbl 7 "Spouse of father becomes stepmother", add
label values momrule momrulelbl

label values poploc poploclbl

label define steppoplbl 0 "No stepfather present"
label define steppoplbl 1 "Improbable age difference", add
label define steppoplbl 2 "Spouse of mother", add
label define steppoplbl 3 "Identified stepfather", add
label values steppop steppoplbl

label define poprulelbl 0 "No father link"
label define poprulelbl 1 "Unambiguous father link", add
label define poprulelbl 2 "Son/granchild link", add
label define poprulelbl 3 "Preceding male (no intervening person)", add
label define poprulelbl 7 "Husband of mother becomes stepfather", add
label values poprule poprulelbl

label values sploc sploclbl

label define sprulelbl 0 "No spouse link", add
label define sprulelbl 1 "Wife follows husband", add
label define sprulelbl 2 "Wife precedes husband", add
label define sprulelbl 3 "Non-adjacent names -- consistent relationship to head/age differences", add
label define sprulelbl 4 "Adjacent names (wife follows husband -- no age, other relative conflicts)", add
label define sprulelbl 5 "Adjacent names (wife precedes husband -- no age, other relative conflicts)", add
label define sprulelbl 6 "Alternate partner (if conflict in rules 1-5 link)", add
label values sprule sprulelbl

label define nchildlbl 0 "0 children present"
label define nchildlbl 1 "1 child present", add
label define nchildlbl 2 "2", add
label define nchildlbl 3 "3", add
label define nchildlbl 4 "4", add
label define nchildlbl 5 "5", add
label define nchildlbl 6 "6", add
label define nchildlbl 7 "7", add
label define nchildlbl 8 "8", add
label define nchildlbl 9 "9+", add
label values nchild nchildlbl

label define eldchlbl 00 "Less than 1 year old"
label define eldchlbl 01 "1", add
label define eldchlbl 02 "2", add
label define eldchlbl 03 "3", add
label define eldchlbl 04 "4", add
label define eldchlbl 05 "5", add
label define eldchlbl 06 "6", add
label define eldchlbl 07 "7", add
label define eldchlbl 08 "8", add
label define eldchlbl 09 "9", add
label define eldchlbl 10 "10", add
label define eldchlbl 11 "11", add
label define eldchlbl 12 "12", add
label define eldchlbl 13 "13", add
label define eldchlbl 14 "14", add
label define eldchlbl 15 "15", add
label define eldchlbl 16 "16", add
label define eldchlbl 17 "17", add
label define eldchlbl 18 "18", add
label define eldchlbl 19 "19", add
label define eldchlbl 20 "20", add
label define eldchlbl 21 "21", add
label define eldchlbl 22 "22", add
label define eldchlbl 23 "23", add
label define eldchlbl 24 "24", add
label define eldchlbl 25 "25", add
label define eldchlbl 26 "26", add
label define eldchlbl 27 "27", add
label define eldchlbl 28 "28", add
label define eldchlbl 29 "29", add
label define eldchlbl 30 "30", add
label define eldchlbl 31 "31", add
label define eldchlbl 32 "32", add
label define eldchlbl 33 "33", add
label define eldchlbl 34 "34", add
label define eldchlbl 35 "35", add
label define eldchlbl 36 "36", add
label define eldchlbl 37 "37", add
label define eldchlbl 38 "38", add
label define eldchlbl 39 "39", add
label define eldchlbl 40 "40", add
label define eldchlbl 41 "41", add
label define eldchlbl 42 "42", add
label define eldchlbl 43 "43", add
label define eldchlbl 44 "44", add
label define eldchlbl 45 "45", add
label define eldchlbl 46 "46", add
label define eldchlbl 47 "47", add
label define eldchlbl 48 "48", add
label define eldchlbl 49 "49", add
label define eldchlbl 50 "50", add
label define eldchlbl 51 "51", add
label define eldchlbl 52 "52", add
label define eldchlbl 53 "53", add
label define eldchlbl 54 "54", add
label define eldchlbl 55 "55", add
label define eldchlbl 56 "56", add
label define eldchlbl 57 "57", add
label define eldchlbl 58 "58", add
label define eldchlbl 59 "59", add
label define eldchlbl 60 "60", add
label define eldchlbl 61 "61", add
label define eldchlbl 62 "62", add
label define eldchlbl 63 "63", add
label define eldchlbl 64 "64", add
label define eldchlbl 65 "65", add
label define eldchlbl 66 "66", add
label define eldchlbl 67 "67", add
label define eldchlbl 68 "68", add
label define eldchlbl 69 "69", add
label define eldchlbl 70 "70", add
label define eldchlbl 71 "71", add
label define eldchlbl 72 "72", add
label define eldchlbl 73 "73", add
label define eldchlbl 74 "74", add
label define eldchlbl 75 "75", add
label define eldchlbl 76 "76", add
label define eldchlbl 77 "77", add
label define eldchlbl 78 "78", add
label define eldchlbl 79 "79", add
label define eldchlbl 80 "80", add
label define eldchlbl 81 "81", add
label define eldchlbl 82 "82", add
label define eldchlbl 83 "83", add
label define eldchlbl 84 "84", add
label define eldchlbl 85 "85", add
label define eldchlbl 86 "86", add
label define eldchlbl 87 "87", add
label define eldchlbl 88 "88", add
label define eldchlbl 89 "89", add
label define eldchlbl 90 "90", add
label define eldchlbl 91 "91", add
label define eldchlbl 92 "92", add
label define eldchlbl 93 "93", add
label define eldchlbl 94 "94", add
label define eldchlbl 95 "95", add
label define eldchlbl 96 "96", add
label define eldchlbl 97 "97", add
label define eldchlbl 98 "98", add
label define eldchlbl 99 "NIU", add
label values eldch eldchlbl

label define yngchlbl 00 "Less than 1 year old"
label define yngchlbl 01 "1", add
label define yngchlbl 02 "2", add
label define yngchlbl 03 "3", add
label define yngchlbl 04 "4", add
label define yngchlbl 05 "5", add
label define yngchlbl 06 "6", add
label define yngchlbl 07 "7", add
label define yngchlbl 08 "8", add
label define yngchlbl 09 "9", add
label define yngchlbl 10 "10", add
label define yngchlbl 11 "11", add
label define yngchlbl 12 "12", add
label define yngchlbl 13 "13", add
label define yngchlbl 14 "14", add
label define yngchlbl 15 "15", add
label define yngchlbl 16 "16", add
label define yngchlbl 17 "17", add
label define yngchlbl 18 "18", add
label define yngchlbl 19 "19", add
label define yngchlbl 20 "20", add
label define yngchlbl 21 "21", add
label define yngchlbl 22 "22", add
label define yngchlbl 23 "23", add
label define yngchlbl 24 "24", add
label define yngchlbl 25 "25", add
label define yngchlbl 26 "26", add
label define yngchlbl 27 "27", add
label define yngchlbl 28 "28", add
label define yngchlbl 29 "29", add
label define yngchlbl 30 "30", add
label define yngchlbl 31 "31", add
label define yngchlbl 32 "32", add
label define yngchlbl 33 "33", add
label define yngchlbl 34 "34", add
label define yngchlbl 35 "35", add
label define yngchlbl 36 "36", add
label define yngchlbl 37 "37", add
label define yngchlbl 38 "38", add
label define yngchlbl 39 "39", add
label define yngchlbl 40 "40", add
label define yngchlbl 41 "41", add
label define yngchlbl 42 "42", add
label define yngchlbl 43 "43", add
label define yngchlbl 44 "44", add
label define yngchlbl 45 "45", add
label define yngchlbl 46 "46", add
label define yngchlbl 47 "47", add
label define yngchlbl 48 "48", add
label define yngchlbl 49 "49", add
label define yngchlbl 50 "50", add
label define yngchlbl 51 "51", add
label define yngchlbl 52 "52", add
label define yngchlbl 53 "53", add
label define yngchlbl 54 "54", add
label define yngchlbl 55 "55", add
label define yngchlbl 56 "56", add
label define yngchlbl 57 "57", add
label define yngchlbl 58 "58", add
label define yngchlbl 59 "59", add
label define yngchlbl 60 "60", add
label define yngchlbl 61 "61", add
label define yngchlbl 62 "62", add
label define yngchlbl 63 "63", add
label define yngchlbl 64 "64", add
label define yngchlbl 65 "65", add
label define yngchlbl 66 "66", add
label define yngchlbl 67 "67", add
label define yngchlbl 68 "68", add
label define yngchlbl 69 "69", add
label define yngchlbl 70 "70", add
label define yngchlbl 71 "71", add
label define yngchlbl 72 "72", add
label define yngchlbl 73 "73", add
label define yngchlbl 74 "74", add
label define yngchlbl 75 "75", add
label define yngchlbl 76 "76", add
label define yngchlbl 77 "77", add
label define yngchlbl 78 "78", add
label define yngchlbl 79 "79", add
label define yngchlbl 80 "80", add
label define yngchlbl 81 "81", add
label define yngchlbl 82 "82", add
label define yngchlbl 83 "83", add
label define yngchlbl 84 "84", add
label define yngchlbl 85 "85", add
label define yngchlbl 86 "86", add
label define yngchlbl 87 "87", add
label define yngchlbl 88 "88", add
label define yngchlbl 89 "89", add
label define yngchlbl 90 "90", add
label define yngchlbl 91 "91", add
label define yngchlbl 92 "92", add
label define yngchlbl 93 "93", add
label define yngchlbl 94 "94", add
label define yngchlbl 95 "95", add
label define yngchlbl 96 "96", add
label define yngchlbl 97 "97", add
label define yngchlbl 98 "98", add
label define yngchlbl 99 "NIU", add
label values yngch yngchlbl

label define relatelbl 0101 "Head/householder", add
label define relatelbl 0201 "Spouse", add
label define relatelbl 0301 "Child", add
label define relatelbl 0303 "Stepchild", add
label define relatelbl 0501 "Parent", add
label define relatelbl 0701 "Sibling", add
label define relatelbl 0901 "Grandchild", add
label define relatelbl 1001 "Other relatives, n.s.", add
label define relatelbl 1113 "Partner/roommate", add
label define relatelbl 1114 "Unmarried partner", add
label define relatelbl 1115 "Housemate/roomate", add
label define relatelbl 1241 "Roomer/boarder/lodger", add
label define relatelbl 1242 "Foster children", add
label define relatelbl 1260 "Other nonrelatives", add
label define relatelbl 9100 "Armed Forces, relationship unknown", add
label define relatelbl 9200 "Age under 14, relationship unknown", add
label define relatelbl 9900 "Relationship unknown", add
label values relate relatelbl

label define agelbl 00 "Under 1 year"
label define agelbl 01 "1", add
label define agelbl 02 "2", add
label define agelbl 03 "3", add
label define agelbl 04 "4", add
label define agelbl 05 "5", add
label define agelbl 06 "6", add
label define agelbl 07 "7", add
label define agelbl 08 "8", add
label define agelbl 09 "9", add
label define agelbl 10 "10", add
label define agelbl 11 "11", add
label define agelbl 12 "12", add
label define agelbl 13 "13", add
label define agelbl 14 "14", add
label define agelbl 15 "15", add
label define agelbl 16 "16", add
label define agelbl 17 "17", add
label define agelbl 18 "18", add
label define agelbl 19 "19", add
label define agelbl 20 "20", add
label define agelbl 21 "21", add
label define agelbl 22 "22", add
label define agelbl 23 "23", add
label define agelbl 24 "24", add
label define agelbl 25 "25", add
label define agelbl 26 "26", add
label define agelbl 27 "27", add
label define agelbl 28 "28", add
label define agelbl 29 "29", add
label define agelbl 30 "30", add
label define agelbl 31 "31", add
label define agelbl 32 "32", add
label define agelbl 33 "33", add
label define agelbl 34 "34", add
label define agelbl 35 "35", add
label define agelbl 36 "36", add
label define agelbl 37 "37", add
label define agelbl 38 "38", add
label define agelbl 39 "39", add
label define agelbl 40 "40", add
label define agelbl 41 "41", add
label define agelbl 42 "42", add
label define agelbl 43 "43", add
label define agelbl 44 "44", add
label define agelbl 45 "45", add
label define agelbl 46 "46", add
label define agelbl 47 "47", add
label define agelbl 48 "48", add
label define agelbl 49 "49", add
label define agelbl 50 "50", add
label define agelbl 51 "51", add
label define agelbl 52 "52", add
label define agelbl 53 "53", add
label define agelbl 54 "54", add
label define agelbl 55 "55", add
label define agelbl 56 "56", add
label define agelbl 57 "57", add
label define agelbl 58 "58", add
label define agelbl 59 "59", add
label define agelbl 60 "60", add
label define agelbl 61 "61", add
label define agelbl 62 "62", add
label define agelbl 63 "63", add
label define agelbl 64 "64", add
label define agelbl 65 "65", add
label define agelbl 66 "66", add
label define agelbl 67 "67", add
label define agelbl 68 "68", add
label define agelbl 69 "69", add
label define agelbl 70 "70", add
label define agelbl 71 "71", add
label define agelbl 72 "72", add
label define agelbl 73 "73", add
label define agelbl 74 "74", add
label define agelbl 75 "75", add
label define agelbl 76 "76", add
label define agelbl 77 "77", add
label define agelbl 78 "78", add
label define agelbl 79 "79", add
label define agelbl 80 "80", add
label define agelbl 81 "81", add
label define agelbl 82 "82", add
label define agelbl 83 "83", add
label define agelbl 84 "84", add
label define agelbl 85 "85", add
label define agelbl 86 "86", add
label define agelbl 87 "87", add
label define agelbl 88 "88", add
label define agelbl 89 "89", add
label define agelbl 90 "90 (90+, 1988-2002)", add
label define agelbl 91 "91", add
label define agelbl 92 "92", add
label define agelbl 93 "93", add
label define agelbl 94 "94", add
label define agelbl 95 "95", add
label define agelbl 96 "96", add
label define agelbl 97 "97", add
label define agelbl 98 "98", add
label define agelbl 99 "99+", add
label values age agelbl

label define sexlbl 1 "Male"
label define sexlbl 2 "Female", add
label values sex sexlbl

label define racelbl 100 "White", add
label define racelbl 200 "Black/Negro", add
label define racelbl 300 "American Indian/Aleut/Eskimo", add
label define racelbl 650 "Asian or Pacific Islander", add
label define racelbl 651 "Asian only", add
label define racelbl 652 "Hawaiian/Pacific Islander only", add
label define racelbl 700 "Other (single) race, n.e.c.", add
label define racelbl 801 "White-Black", add
label define racelbl 802 "White-American Indian", add
label define racelbl 803 "White-Asian", add
label define racelbl 804 "White-Hawaiian/Pacific Islander", add
label define racelbl 805 "Black-American Indian", add
label define racelbl 806 "Black-Asian", add
label define racelbl 807 "Black-Hawaiian/Pacific Islander", add
label define racelbl 808 "American Indian-Asian", add
label define racelbl 809 "Asian-Hawaiian/Pacific Islander", add
label define racelbl 810 "White-Black-American Indian", add
label define racelbl 811 "White-Black-Asian", add
label define racelbl 812 "White-American Indian-Asian", add
label define racelbl 813 "White-Asian-Hawaiian/Pacific Islander", add
label define racelbl 814 "White-Black-American Indian-Asian", add
label define racelbl 820 "Two or three races, unspecified", add
label define racelbl 830 "Four or five races, unspecified", add
label values race racelbl

label define marstlbl 1 "Married, spouse present"
label define marstlbl 2 "Married, spouse absent", add
label define marstlbl 3 "Separated", add
label define marstlbl 4 "Divorced", add
label define marstlbl 5 "Widowed", add
label define marstlbl 6 "Never married/single", add
label define marstlbl 9 "Unknown", add
label values marst marstlbl

label define hispanlbl 000 "Not Hispanic", add
label define hispanlbl 100 "Mexican", add
label define hispanlbl 102 "Mexican American", add
label define hispanlbl 103 "Mexicano/Mexicana", add
label define hispanlbl 104 "Chicano/Chicana", add
label define hispanlbl 108 "Mexican (Mexicano)", add
label define hispanlbl 109 "Mexicano/Chicano", add
label define hispanlbl 200 "Puerto Rican", add
label define hispanlbl 300 "Cuban", add
label define hispanlbl 400 "Other Spanish", add
label define hispanlbl 410 "Central/South American", add
label define hispanlbl 901 "Do not know", add
label define hispanlbl 902 "N/A (and no response 1985-87)", add
label values hispan hispanlbl

label define educreclbl 00 "NIU"
label define educreclbl 01 "None or preschool", add
label define educreclbl 02 "Grades 1, 2, 3, or 4", add
label define educreclbl 03 "Grades 5, 6, 7, or 8", add
label define educreclbl 04 "Grade 9", add
label define educreclbl 05 "Grade 10", add
label define educreclbl 06 "Grade 11", add
label define educreclbl 07 "Grade 12", add
label define educreclbl 08 "1 to 3 years of college", add
label define educreclbl 09 "4+ years of college", add
label define educreclbl 99 "Missing/Unknown", add
label values educrec educreclbl

label define empstatlbl 00 "NIU", add
label define empstatlbl 10 "At work", add
label define empstatlbl 12 "Has job, not at work last week", add
label define empstatlbl 13 "Armed Forces", add
label define empstatlbl 20 "Unemployed", add
label define empstatlbl 21 "Unemployed, experienced worker", add
label define empstatlbl 22 "Unemployed, new worker", add
label define empstatlbl 30 "Not in labor force", add
label define empstatlbl 31 "NILF, housework", add
label define empstatlbl 32 "NILF, unable to work", add
label define empstatlbl 33 "NILF, school", add
label define empstatlbl 34 "NILF, other", add
label define empstatlbl 35 "NILF, unpaid, lt 15 hours", add
label values empstat empstatlbl

label define occ1950lbl 000 "Accountants and auditors", add
label define occ1950lbl 001 "Actors and actresses", add
label define occ1950lbl 002 "Airplane pilots and navigators", add
label define occ1950lbl 003 "Architects", add
label define occ1950lbl 004 "Artists and art teachers", add
label define occ1950lbl 005 "Athletes", add
label define occ1950lbl 006 "Authors", add
label define occ1950lbl 007 "Chemists", add
label define occ1950lbl 008 "Chiropractors", add
label define occ1950lbl 009 "Clergymen", add
label define occ1950lbl 010 "College presidents and deans", add
label define occ1950lbl 012 "Agricultural sciences", add
label define occ1950lbl 013 "Biological sciences", add
label define occ1950lbl 014 "Chemistry", add
label define occ1950lbl 015 "Economics", add
label define occ1950lbl 016 "Engineering", add
label define occ1950lbl 017 "Geology and geophysics", add
label define occ1950lbl 018 "Mathematics", add
label define occ1950lbl 019 "Medical sciences", add
label define occ1950lbl 023 "Physics", add
label define occ1950lbl 024 "Psychology", add
label define occ1950lbl 025 "Statistics", add
label define occ1950lbl 026 "Natural science (n.e.c.)", add
label define occ1950lbl 027 "Social sciences (n.e.c.)", add
label define occ1950lbl 028 "Nonscientific subjects", add
label define occ1950lbl 029 "Subject not specified", add
label define occ1950lbl 031 "Dancers and dancing teachers", add
label define occ1950lbl 032 "Dentists", add
label define occ1950lbl 033 "Designers", add
label define occ1950lbl 034 "Dieticians and nutritionists", add
label define occ1950lbl 035 "Draftsmen", add
label define occ1950lbl 036 "Editors and reporters", add
label define occ1950lbl 041 "Engineers, aeronautical", add
label define occ1950lbl 042 "Engineers, chemical", add
label define occ1950lbl 043 "Engineers, civil", add
label define occ1950lbl 044 "Engineers, electrical", add
label define occ1950lbl 045 "Engineers, industrial", add
label define occ1950lbl 046 "Engineers, mechanical", add
label define occ1950lbl 047 "Engineers, metallurgical, metallurgists", add
label define occ1950lbl 048 "Engineers, mining", add
label define occ1950lbl 049 "Engineers (n.e.c.)", add
label define occ1950lbl 051 "Entertainers (n.e.c.)", add
label define occ1950lbl 052 "Farm and home management advisors", add
label define occ1950lbl 053 "Foresters and conservationists", add
label define occ1950lbl 054 "Funeral directors and embalmers", add
label define occ1950lbl 055 "Lawyers and judges", add
label define occ1950lbl 056 "Librarians", add
label define occ1950lbl 057 "Musicians and music teachers", add
label define occ1950lbl 058 "Nurses, professional", add
label define occ1950lbl 059 "Nurses, student professional", add
label define occ1950lbl 061 "Agricultural scientists", add
label define occ1950lbl 062 "Biological scientists", add
label define occ1950lbl 063 "Geologists and geophysicists", add
label define occ1950lbl 067 "Mathematicians", add
label define occ1950lbl 068 "Physicists", add
label define occ1950lbl 069 "Miscellaneous natural scientists", add
label define occ1950lbl 070 "Optometrists", add
label define occ1950lbl 071 "Osteopaths", add
label define occ1950lbl 072 "Personnel and labor relations workers", add
label define occ1950lbl 073 "Pharmacists", add
label define occ1950lbl 074 "Photographers", add
label define occ1950lbl 075 "Physicians and surgeons", add
label define occ1950lbl 076 "Radio operators", add
label define occ1950lbl 077 "Recreation and group workers", add
label define occ1950lbl 078 "Religious workers", add
label define occ1950lbl 079 "Social and welfare workers, except group", add
label define occ1950lbl 081 "Economists", add
label define occ1950lbl 082 "Psychologists", add
label define occ1950lbl 083 "Statisticians and actuaries", add
label define occ1950lbl 084 "Miscellaneous social scientists", add
label define occ1950lbl 091 "Sports instructors and officials", add
label define occ1950lbl 092 "Surveyors", add
label define occ1950lbl 093 "Teachers (n.e.c.)", add
label define occ1950lbl 094 "Technicians, medical and dental", add
label define occ1950lbl 095 "Technicians, testing", add
label define occ1950lbl 096 "Technicians (n.e.c.)", add
label define occ1950lbl 097 "Therapists and healers (n.e.c.)", add
label define occ1950lbl 098 "Veterinarians", add
label define occ1950lbl 099 "Professional, technical and kindred workers (n.e.c.)", add
label define occ1950lbl 100 "Farmers (owners and tenants)", add
label define occ1950lbl 123 "Farm managers", add
label define occ1950lbl 200 "Buyers and department heads, store", add
label define occ1950lbl 201 "Buyers and shippers, farm products", add
label define occ1950lbl 203 "Conductors, railroad", add
label define occ1950lbl 204 "Credit men", add
label define occ1950lbl 205 "Floormen and floor managers, store", add
label define occ1950lbl 210 "Inspectors, public administration", add
label define occ1950lbl 230 "Managers and superintendents, building", add
label define occ1950lbl 240 "Officers, pilots, pursers and engineers, ship", add
label define occ1950lbl 250 "Officials and administrators (n.e.c.), public administration", add
label define occ1950lbl 260 "Officials, lodge, society, union, etc.", add
label define occ1950lbl 270 "Postmasters", add
label define occ1950lbl 280 "Purchasing agents and buyers (n.e.c.)", add
label define occ1950lbl 290 "Managers, officials, and proprietors (n.e.c.)", add
label define occ1950lbl 300 "Agents (n.e.c.)", add
label define occ1950lbl 301 "Attendants and assistants, library", add
label define occ1950lbl 302 "Attendants, physicians and dentists office", add
label define occ1950lbl 304 "Baggagemen, transportation", add
label define occ1950lbl 305 "Bank tellers", add
label define occ1950lbl 310 "Bookkeepers", add
label define occ1950lbl 320 "Cashiers", add
label define occ1950lbl 321 "Collectors, bill and account", add
label define occ1950lbl 322 "Dispatchers and starters, vehicle", add
label define occ1950lbl 325 "Express messengers and railway mail clerks", add
label define occ1950lbl 335 "Mail carriers", add
label define occ1950lbl 340 "Messengers and office boys", add
label define occ1950lbl 341 "Office machine operators", add
label define occ1950lbl 342 "Shipping and receiving clerks", add
label define occ1950lbl 350 "Stenographers, typists, and secretaries", add
label define occ1950lbl 360 "Telegraph messengers", add
label define occ1950lbl 365 "Telegraph operators", add
label define occ1950lbl 370 "Telephone operators", add
label define occ1950lbl 380 "Ticket, station, and express agents", add
label define occ1950lbl 390 "Clerical and kindred workers (n.e.c.)", add
label define occ1950lbl 400 "Advertising agents and salesmen", add
label define occ1950lbl 410 "Auctioneers", add
label define occ1950lbl 420 "Demonstrators", add
label define occ1950lbl 430 "Hucksters and peddlers", add
label define occ1950lbl 450 "Insurance agents and brokers", add
label define occ1950lbl 460 "Newsboys", add
label define occ1950lbl 470 "Real estate agents and brokers", add
label define occ1950lbl 480 "Stock and bond salesmen", add
label define occ1950lbl 490 "Salesmen and sales clerks (n.e.c.)", add
label define occ1950lbl 500 "Bakers", add
label define occ1950lbl 501 "Blacksmiths", add
label define occ1950lbl 502 "Bookbinders", add
label define occ1950lbl 503 "Boilermakers", add
label define occ1950lbl 504 "Brickmasons, stonemasons, and tile setters", add
label define occ1950lbl 505 "Cabinetmakers", add
label define occ1950lbl 510 "Carpenters", add
label define occ1950lbl 511 "Cement and concrete finishers", add
label define occ1950lbl 512 "Compositors and typesetters", add
label define occ1950lbl 513 "Cranemen, derrickmen, and hoistmen", add
label define occ1950lbl 514 "Decorators and window dressers", add
label define occ1950lbl 515 "Electricians", add
label define occ1950lbl 520 "Electrotypers and stereotypers", add
label define occ1950lbl 521 "Engravers, except photoengravers", add
label define occ1950lbl 522 "Excavating, grading, and road machinery operators", add
label define occ1950lbl 523 "Foremen (n.e.c.)", add
label define occ1950lbl 524 "Forgemen and hammermen", add
label define occ1950lbl 525 "Furriers", add
label define occ1950lbl 530 "Glaziers", add
label define occ1950lbl 531 "Heat treaters, annealers, temperers", add
label define occ1950lbl 532 "Inspectors, scalers, and graders, log and lumber", add
label define occ1950lbl 533 "Inspectors (n.e.c.)", add
label define occ1950lbl 534 "Jewelers, watchmakers, goldsmiths, and silversmiths", add
label define occ1950lbl 535 "Job setters, metal", add
label define occ1950lbl 540 "Linemen and servicemen, telegraph, telephone, and power", add
label define occ1950lbl 541 "Locomotive engineers", add
label define occ1950lbl 542 "Locomotive firemen", add
label define occ1950lbl 543 "Loom fixers", add
label define occ1950lbl 544 "Machinists", add
label define occ1950lbl 545 "Mechanics and repairmen, airplane", add
label define occ1950lbl 550 "Mechanics and repairmen, automobile", add
label define occ1950lbl 551 "Mechanics and repairmen, office machine", add
label define occ1950lbl 552 "Mechanics and repairmen, radio and television", add
label define occ1950lbl 553 "Mechanics and repairmen, railroad and car shop", add
label define occ1950lbl 554 "Mechanics and repairmen (n.e.c.)", add
label define occ1950lbl 555 "Millers, grain, flour, feed, etc.", add
label define occ1950lbl 560 "Millwrights", add
label define occ1950lbl 561 "Molders, metal", add
label define occ1950lbl 562 "Motion picture projectionists", add
label define occ1950lbl 563 "Opticians and lens grinders and polishers", add
label define occ1950lbl 564 "Painters, construction and maintenance", add
label define occ1950lbl 565 "Paperhangers", add
label define occ1950lbl 570 "Pattern and model makers, except paper", add
label define occ1950lbl 571 "Photoengravers and lithographers", add
label define occ1950lbl 572 "Piano and organ tuners and repairmen", add
label define occ1950lbl 573 "Plasterers", add
label define occ1950lbl 574 "Plumbers and pipe fitters", add
label define occ1950lbl 575 "Pressmen and plate printers, printing", add
label define occ1950lbl 580 "Rollers and roll hands, metal", add
label define occ1950lbl 581 "Roofers and slaters", add
label define occ1950lbl 582 "Shoemakers and repairers, except factory", add
label define occ1950lbl 583 "Stationary engineers", add
label define occ1950lbl 584 "Stone cutters and stone carvers", add
label define occ1950lbl 585 "Structural metal workers", add
label define occ1950lbl 590 "Tailors and tailoresses", add
label define occ1950lbl 591 "Tinsmiths, coppersmiths, and sheet metal workers", add
label define occ1950lbl 592 "Tool makers, and die makers and setters", add
label define occ1950lbl 593 "Upholsterers", add
label define occ1950lbl 594 "Craftsmen and kindred workers (n.e.c.)", add
label define occ1950lbl 595 "Members of the armed services", add
label define occ1950lbl 600 "Apprentice auto mechanics", add
label define occ1950lbl 601 "Apprentice bricklayers and masons", add
label define occ1950lbl 602 "Apprentice carpenters", add
label define occ1950lbl 603 "Apprentice electricians", add
label define occ1950lbl 604 "Apprentice machinists and toolmakers", add
label define occ1950lbl 605 "Apprentice mechanics, except auto", add
label define occ1950lbl 610 "Apprentice plumbers and pipe fitters", add
label define occ1950lbl 611 "Apprentices, building trades (n.e.c.)", add
label define occ1950lbl 612 "Apprentices, metalworking trades (n.e.c.)", add
label define occ1950lbl 613 "Apprentices, printing trades", add
label define occ1950lbl 614 "Apprentices, other specified trades", add
label define occ1950lbl 615 "Apprentices, trade not specified", add
label define occ1950lbl 620 "Asbestos and insulation workers", add
label define occ1950lbl 621 "Attendants, auto service and parking", add
label define occ1950lbl 622 "Blasters and powdermen", add
label define occ1950lbl 623 "Boatmen, canalmen, and lock keepers", add
label define occ1950lbl 624 "Brakemen, railroad", add
label define occ1950lbl 625 "Bus drivers", add
label define occ1950lbl 630 "Chainmen, rodmen, and axmen, surveying", add
label define occ1950lbl 631 "Conductors, bus and street railway", add
label define occ1950lbl 632 "Deliverymen and routemen", add
label define occ1950lbl 633 "Dressmakers and seamstresses, except factory", add
label define occ1950lbl 634 "Dyers", add
label define occ1950lbl 635 "Filers, grinders, and polishers, metal", add
label define occ1950lbl 640 "Fruit, nut, veg graders and packers, except factory", add
label define occ1950lbl 641 "Furnacemen, smeltermen and pourers", add
label define occ1950lbl 642 "Heaters, metal", add
label define occ1950lbl 643 "Laundry and dry cleaning operatives", add
label define occ1950lbl 644 "Meat cutters, except slaughter and packing house", add
label define occ1950lbl 645 "Milliners", add
label define occ1950lbl 650 "Mine operatives and laborers", add
label define occ1950lbl 660 "Motormen, mine, factory, logging camp, etc.", add
label define occ1950lbl 661 "Motormen, street, subway, and elevated railway", add
label define occ1950lbl 662 "Oilers and greaser, except auto", add
label define occ1950lbl 670 "Painters, except construction or maintenance", add
label define occ1950lbl 671 "Photographic process workers", add
label define occ1950lbl 672 "Power station operators", add
label define occ1950lbl 673 "Sailors and deck hands", add
label define occ1950lbl 674 "Sawyers", add
label define occ1950lbl 675 "Spinners, textile", add
label define occ1950lbl 680 "Stationary firemen", add
label define occ1950lbl 681 "Switchmen, railroad", add
label define occ1950lbl 682 "Taxicab drivers and chauffers", add
label define occ1950lbl 683 "Truck and tractor drivers", add
label define occ1950lbl 684 "Weavers, textile", add
label define occ1950lbl 685 "Welders and flame cutters", add
label define occ1950lbl 690 "Operative and kindred workers (n.e.c.)", add
label define occ1950lbl 700 "Housekeepers, private household", add
label define occ1950lbl 710 "Laundressses, private household", add
label define occ1950lbl 720 "Private household workers (n.e.c.)", add
label define occ1950lbl 730 "Attendants, hospital and other institution", add
label define occ1950lbl 731 "Attendants, professional and personal service (n.e.c.)", add
label define occ1950lbl 732 "Attendants, recreation and amusement", add
label define occ1950lbl 740 "Barbers, beauticians, and manicurists", add
label define occ1950lbl 750 "Bartenders", add
label define occ1950lbl 751 "Bootblacks", add
label define occ1950lbl 752 "Boarding and lodging house keepers", add
label define occ1950lbl 753 "Charwomen and cleaners", add
label define occ1950lbl 754 "Cooks, except private household", add
label define occ1950lbl 760 "Counter and fountain workers", add
label define occ1950lbl 761 "Elevator operators", add
label define occ1950lbl 762 "Firemen, fire protection", add
label define occ1950lbl 763 "Guards, watchmen, and doorkeepers", add
label define occ1950lbl 764 "Housekeepers and stewards, except private household", add
label define occ1950lbl 770 "Janitors and sextons", add
label define occ1950lbl 771 "Marshals and constables", add
label define occ1950lbl 772 "Midwives", add
label define occ1950lbl 773 "Policemen and detectives", add
label define occ1950lbl 780 "Porters", add
label define occ1950lbl 781 "Practical nurses", add
label define occ1950lbl 782 "Sheriffs and bailiffs", add
label define occ1950lbl 783 "Ushers, recreation and amusement", add
label define occ1950lbl 784 "Waiters and waitresses", add
label define occ1950lbl 785 "Watchmen (crossing) and bridge tenders", add
label define occ1950lbl 790 "Service workers, except private household (n.e.c.)", add
label define occ1950lbl 810 "Farm foremen", add
label define occ1950lbl 820 "Farm laborers, wage workers", add
label define occ1950lbl 830 "Farm laborers, unpaid family workers", add
label define occ1950lbl 840 "Farm service laborers, self-employed", add
label define occ1950lbl 910 "Fishermen and oystermen", add
label define occ1950lbl 920 "Garage laborers and car washers and greasers", add
label define occ1950lbl 930 "Gardeners, except farm, and groundskeepers", add
label define occ1950lbl 940 "Longshoremen and stevedores", add
label define occ1950lbl 950 "Lumbermen, raftsmen, and woodchoppers", add
label define occ1950lbl 960 "Teamsters", add
label define occ1950lbl 970 "Laborers (n.e.c.)", add
label define occ1950lbl 997 "Unknown", add
label define occ1950lbl 999 "Unemployed- last worked over x years ago", add
label values occ1950 occ1950lbl

label define ind1950lbl 000 "NIU", add
label define ind1950lbl 105 "Agriculture", add
label define ind1950lbl 116 "Forestry", add
label define ind1950lbl 126 "Fisheries", add
label define ind1950lbl 206 "Metal mining", add
label define ind1950lbl 216 "Coal mining", add
label define ind1950lbl 226 "Crude petroleum and natural gas extraction", add
label define ind1950lbl 236 "Nonmetallic mining and quarrying, except fuel", add
label define ind1950lbl 246 "Construction", add
label define ind1950lbl 306 "Logging", add
label define ind1950lbl 307 "Sawmills, planing mills, and millwork", add
label define ind1950lbl 308 "Misc wood products", add
label define ind1950lbl 309 "Furniture and fixtures", add
label define ind1950lbl 316 "Glass and glass products", add
label define ind1950lbl 317 "Cement, concrete, gypsum and plaster products", add
label define ind1950lbl 318 "Structural clay products", add
label define ind1950lbl 319 "Pottery and related products", add
label define ind1950lbl 326 "Miscellaneous nonmetallic mineral and stone products", add
label define ind1950lbl 336 "Blast furnaces, steel works, and rolling mills", add
label define ind1950lbl 337 "Other primary iron and steel industries", add
label define ind1950lbl 338 "Primary nonferrous industries", add
label define ind1950lbl 346 "Fabricated steel products", add
label define ind1950lbl 347 "Fabricated nonferrous metal products", add
label define ind1950lbl 348 "Not specified metal industries", add
label define ind1950lbl 356 "Agricultural machinery and tractors", add
label define ind1950lbl 357 "Office and store machines and devices", add
label define ind1950lbl 358 "Miscellaneous machinery", add
label define ind1950lbl 367 "Electrical machinery, equipment, and supplies", add
label define ind1950lbl 376 "Motor vehicles and motor vehicle equipment", add
label define ind1950lbl 377 "Aircraft and parts", add
label define ind1950lbl 378 "Ship and boat building and repairing", add
label define ind1950lbl 379 "Railroad and miscellaneous transportation equipment", add
label define ind1950lbl 386 "Professional equipment and supplies", add
label define ind1950lbl 387 "Photographic equipment and supplies", add
label define ind1950lbl 388 "Watches, clocks, and clockwork-operated devices", add
label define ind1950lbl 399 "Miscellaneous manufacturing industries", add
label define ind1950lbl 406 "Meat products", add
label define ind1950lbl 407 "Dairy products", add
label define ind1950lbl 408 "Canning and preserving fruits, vegetables, and seafoods", add
label define ind1950lbl 409 "Grain-mill products", add
label define ind1950lbl 416 "Bakery products", add
label define ind1950lbl 417 "Confectionery and related products", add
label define ind1950lbl 418 "Beverage industries", add
label define ind1950lbl 419 "Miscellaneous food preparations and kindred products", add
label define ind1950lbl 426 "Not specified food industries", add
label define ind1950lbl 429 "Tobacco manufactures", add
label define ind1950lbl 436 "Knitting mills", add
label define ind1950lbl 437 "Dyeing and finishing textiles, except knit goods", add
label define ind1950lbl 438 "Carpets, rugs, and other floor coverings", add
label define ind1950lbl 439 "Yarn, thread, and fabric mills", add
label define ind1950lbl 446 "Miscellaneous textile mill products", add
label define ind1950lbl 448 "Apparel and accessories", add
label define ind1950lbl 449 "Miscellaneous fabricated textile products", add
label define ind1950lbl 456 "Pulp, paper, and paperboard mills", add
label define ind1950lbl 457 "Paperboard containers and boxes", add
label define ind1950lbl 458 "Miscellaneous paper and pulp products", add
label define ind1950lbl 459 "Printing, publishing, and allied industries", add
label define ind1950lbl 466 "Synthetic fibers", add
label define ind1950lbl 467 "Drugs and medicines", add
label define ind1950lbl 468 "Paints, varnishes, and related products", add
label define ind1950lbl 469 "Miscellaneous chemicals and allied products", add
label define ind1950lbl 476 "Petroleum refining", add
label define ind1950lbl 477 "Miscellaneous petroleum and coal products", add
label define ind1950lbl 478 "Rubber products", add
label define ind1950lbl 487 "Leather: tanned, curried, and finished", add
label define ind1950lbl 488 "Footwear, except rubber", add
label define ind1950lbl 489 "Leather products, except footwear", add
label define ind1950lbl 499 "Not specified manufacturing industries", add
label define ind1950lbl 506 "Railroads and railway express service", add
label define ind1950lbl 516 "Street railways and bus lines", add
label define ind1950lbl 526 "Trucking service", add
label define ind1950lbl 527 "Warehousing and storage", add
label define ind1950lbl 536 "Taxicab service", add
label define ind1950lbl 546 "Water transportation", add
label define ind1950lbl 556 "Air transportation", add
label define ind1950lbl 567 "Petroleum and gasoline pipe lines", add
label define ind1950lbl 568 "Services incidental to transportation", add
label define ind1950lbl 578 "Telephone", add
label define ind1950lbl 579 "Telegraph", add
label define ind1950lbl 586 "Electric light and power", add
label define ind1950lbl 587 "Gas and steam supply systems", add
label define ind1950lbl 588 "Electric-gas utilities", add
label define ind1950lbl 596 "Water supply", add
label define ind1950lbl 597 "Sanitary services", add
label define ind1950lbl 598 "Other and not specified utilities", add
label define ind1950lbl 606 "Motor vehicles and equipment", add
label define ind1950lbl 607 "Drugs, chemicals, and allied products", add
label define ind1950lbl 608 "Dry goods apparel", add
label define ind1950lbl 609 "Food and related products", add
label define ind1950lbl 616 "Electrical goods, hardware, and plumbing equipment", add
label define ind1950lbl 617 "Machinery, equipment, and supplies", add
label define ind1950lbl 618 "Petroleum products", add
label define ind1950lbl 619 "Farm products--raw materials", add
label define ind1950lbl 626 "Miscellaneous wholesale trade", add
label define ind1950lbl 627 "Not specified wholesale trade", add
label define ind1950lbl 636 "Food stores, except dairy products", add
label define ind1950lbl 637 "Dairy products stores and milk retailing", add
label define ind1950lbl 646 "General merchandise stores", add
label define ind1950lbl 647 "Five and ten cent stores", add
label define ind1950lbl 656 "Apparel and accessories stores, except shoe", add
label define ind1950lbl 657 "Shoe stores", add
label define ind1950lbl 658 "Furniture and house furnishing stores", add
label define ind1950lbl 659 "Household appliance and radio stores", add
label define ind1950lbl 667 "Motor vehicles and accessories retailing", add
label define ind1950lbl 668 "Gasoline service stations", add
label define ind1950lbl 669 "Drug stores", add
label define ind1950lbl 679 "Eating and drinking places", add
label define ind1950lbl 686 "Hardware and farm implement stores", add
label define ind1950lbl 687 "Lumber and building material retailing", add
label define ind1950lbl 688 "Liquor stores", add
label define ind1950lbl 689 "Retail florists", add
label define ind1950lbl 696 "Jewelry stores", add
label define ind1950lbl 697 "Fuel and ice retailing", add
label define ind1950lbl 698 "Miscellaneous retail stores", add
label define ind1950lbl 699 "Not specified retail trade", add
label define ind1950lbl 716 "Banking and credit agencies", add
label define ind1950lbl 726 "Security and commodity brokerage and investment companies", add
label define ind1950lbl 736 "Insurance", add
label define ind1950lbl 746 "Real estate", add
label define ind1950lbl 806 "Advertising", add
label define ind1950lbl 807 "Accounting, auditing, and bookkeeping services", add
label define ind1950lbl 808 "Miscellaneous business services", add
label define ind1950lbl 816 "Auto repair services and garages", add
label define ind1950lbl 817 "Miscellaneous repair services", add
label define ind1950lbl 826 "Private households", add
label define ind1950lbl 836 "Hotels and lodging places", add
label define ind1950lbl 846 "Laundering, cleaning, and dyeing services", add
label define ind1950lbl 847 "Dressmaking shops", add
label define ind1950lbl 848 "Shoe repair shops", add
label define ind1950lbl 849 "Miscellaneous personal services", add
label define ind1950lbl 856 "Radio broadcasting and television", add
label define ind1950lbl 857 "Theaters and motion pictures", add
label define ind1950lbl 858 "Bowling alleys, and billiard and pool parlors", add
label define ind1950lbl 859 "Miscellaneous entertainment and recreation services", add
label define ind1950lbl 868 "Medical and other health services, except hospitals", add
label define ind1950lbl 869 "Hospitals", add
label define ind1950lbl 879 "Legal services", add
label define ind1950lbl 888 "Educational services", add
label define ind1950lbl 896 "Welfare and religious services", add
label define ind1950lbl 897 "Nonprofit membership organizations", add
label define ind1950lbl 898 "Engineering and architectural services", add
label define ind1950lbl 899 "Miscellaneous professional and related services", add
label define ind1950lbl 906 "Postal service", add
label define ind1950lbl 916 "Federal public administration", add
label define ind1950lbl 926 "State public administration", add
label define ind1950lbl 936 "Local public administration", add
label define ind1950lbl 997 "Nonclassifiable", add
label define ind1950lbl 998 "Industry not reported", add
label values ind1950 ind1950lbl

label define classwkrlbl 00 "NIU"
label define classwkrlbl 10 "Self-employed", add
label define classwkrlbl 13 "Self-employed, not incorporated", add
label define classwkrlbl 14 "Self-employed, incorporated", add
label define classwkrlbl 20 "Works for wages or salary", add
label define classwkrlbl 22 "Wage/salary, private", add
label define classwkrlbl 24 "Wage/salary, government", add
label define classwkrlbl 25 "Federal government employee", add
label define classwkrlbl 26 "Armed forces", add
label define classwkrlbl 27 "State government employee", add
label define classwkrlbl 28 "Local government employee", add
label define classwkrlbl 29 "Unpaid family worker", add
label define classwkrlbl 99 "Missing/Unknown", add
label values classwkr classwkrlbl

label define wkswork1lbl 00 "NIU"
label define wkswork1lbl 01 "1 week", add
label define wkswork1lbl 02 "2 weeks", add
label define wkswork1lbl 03 "3 weeks", add
label define wkswork1lbl 04 "4 weeks", add
label define wkswork1lbl 05 "5 weeks", add
label define wkswork1lbl 06 "6 weeks", add
label define wkswork1lbl 07 "7 weeks", add
label define wkswork1lbl 08 "8 weeks", add
label define wkswork1lbl 09 "9 weeks", add
label define wkswork1lbl 10 "10 weeks", add
label define wkswork1lbl 11 "11 weeks", add
label define wkswork1lbl 12 "12 weeks", add
label define wkswork1lbl 13 "13 weeks", add
label define wkswork1lbl 14 "14 weeks", add
label define wkswork1lbl 15 "15 weeks", add
label define wkswork1lbl 16 "16 weeks", add
label define wkswork1lbl 17 "17 weeks", add
label define wkswork1lbl 18 "18 weeks", add
label define wkswork1lbl 19 "19 weeks", add
label define wkswork1lbl 20 "20 weeks", add
label define wkswork1lbl 21 "21 weeks", add
label define wkswork1lbl 22 "22 weeks", add
label define wkswork1lbl 23 "23 weeks", add
label define wkswork1lbl 24 "24 weeks", add
label define wkswork1lbl 25 "25 weeks", add
label define wkswork1lbl 26 "26 weeks", add
label define wkswork1lbl 27 "27 weeks", add
label define wkswork1lbl 28 "28 weeks", add
label define wkswork1lbl 29 "29 weeks", add
label define wkswork1lbl 30 "30 weeks", add
label define wkswork1lbl 31 "31 weeks", add
label define wkswork1lbl 32 "32 weeks", add
label define wkswork1lbl 33 "33 weeks", add
label define wkswork1lbl 34 "34 weeks", add
label define wkswork1lbl 35 "35 weeks", add
label define wkswork1lbl 36 "36 weeks", add
label define wkswork1lbl 37 "37 weeks", add
label define wkswork1lbl 38 "38 weeks", add
label define wkswork1lbl 39 "39 weeks", add
label define wkswork1lbl 40 "40 weeks", add
label define wkswork1lbl 41 "41 weeks", add
label define wkswork1lbl 42 "42 weeks", add
label define wkswork1lbl 43 "43 weeks", add
label define wkswork1lbl 44 "44 weeks", add
label define wkswork1lbl 45 "45 weeks", add
label define wkswork1lbl 46 "46 weeks", add
label define wkswork1lbl 47 "47 weeks", add
label define wkswork1lbl 48 "48 weeks", add
label define wkswork1lbl 49 "49 weeks", add
label define wkswork1lbl 50 "50 weeks", add
label define wkswork1lbl 51 "51 weeks", add
label define wkswork1lbl 52 "52 weeks", add
label values wkswork1 wkswork1lbl

label define hrsworklbl 00 "NIU"
label define hrsworklbl 01 "1 hour", add
label define hrsworklbl 02 "2 hours", add
label define hrsworklbl 03 "3 hours", add
label define hrsworklbl 04 "4 hours", add
label define hrsworklbl 05 "5 hours", add
label define hrsworklbl 06 "6 hours", add
label define hrsworklbl 07 "7 hours", add
label define hrsworklbl 08 "8 hours", add
label define hrsworklbl 09 "9 hours", add
label define hrsworklbl 10 "10 hours", add
label define hrsworklbl 11 "11 hours", add
label define hrsworklbl 12 "12 hours", add
label define hrsworklbl 13 "13 hours", add
label define hrsworklbl 14 "14 hours", add
label define hrsworklbl 15 "15 hours", add
label define hrsworklbl 16 "16 hours", add
label define hrsworklbl 17 "17 hours", add
label define hrsworklbl 18 "18 hours", add
label define hrsworklbl 19 "19 hours", add
label define hrsworklbl 20 "20 hours", add
label define hrsworklbl 21 "21 hours", add
label define hrsworklbl 22 "22 hours", add
label define hrsworklbl 23 "23 hours", add
label define hrsworklbl 24 "24 hours", add
label define hrsworklbl 25 "25 hours", add
label define hrsworklbl 26 "26 hours", add
label define hrsworklbl 27 "27 hours", add
label define hrsworklbl 28 "28 hours", add
label define hrsworklbl 29 "29 hours", add
label define hrsworklbl 30 "30 hours", add
label define hrsworklbl 31 "31 hours", add
label define hrsworklbl 32 "32 hours", add
label define hrsworklbl 33 "33 hours", add
label define hrsworklbl 34 "34 hours", add
label define hrsworklbl 35 "35 hours", add
label define hrsworklbl 36 "36 hours", add
label define hrsworklbl 37 "37 hours", add
label define hrsworklbl 38 "38 hours", add
label define hrsworklbl 39 "39 hours", add
label define hrsworklbl 40 "40 hours", add
label define hrsworklbl 41 "41 hours", add
label define hrsworklbl 42 "42 hours", add
label define hrsworklbl 43 "43 hours", add
label define hrsworklbl 44 "44 hours", add
label define hrsworklbl 45 "45 hours", add
label define hrsworklbl 46 "46 hours", add
label define hrsworklbl 47 "47 hours", add
label define hrsworklbl 48 "48 hours", add
label define hrsworklbl 49 "49 hours", add
label define hrsworklbl 50 "50 hours", add
label define hrsworklbl 51 "51 hours", add
label define hrsworklbl 52 "52 hours", add
label define hrsworklbl 53 "53 hours", add
label define hrsworklbl 54 "54 hours", add
label define hrsworklbl 55 "55 hours", add
label define hrsworklbl 56 "56 hours", add
label define hrsworklbl 57 "57 hours", add
label define hrsworklbl 58 "58 hours", add
label define hrsworklbl 59 "59 hours", add
label define hrsworklbl 60 "60 hours", add
label define hrsworklbl 61 "61 hours", add
label define hrsworklbl 62 "62 hours", add
label define hrsworklbl 63 "63 hours", add
label define hrsworklbl 64 "64 hours", add
label define hrsworklbl 65 "65 hours", add
label define hrsworklbl 66 "66 hours", add
label define hrsworklbl 67 "67 hours", add
label define hrsworklbl 68 "68 hours", add
label define hrsworklbl 69 "69 hours", add
label define hrsworklbl 70 "70 hours", add
label define hrsworklbl 71 "71 hours", add
label define hrsworklbl 72 "72 hours", add
label define hrsworklbl 73 "73 hours", add
label define hrsworklbl 74 "74 hours", add
label define hrsworklbl 75 "75 hours", add
label define hrsworklbl 76 "76 hours", add
label define hrsworklbl 77 "77 hours", add
label define hrsworklbl 78 "78 hours", add
label define hrsworklbl 79 "79 hours", add
label define hrsworklbl 80 "80 hours", add
label define hrsworklbl 81 "81 hours", add
label define hrsworklbl 82 "82 hours", add
label define hrsworklbl 83 "83 hours", add
label define hrsworklbl 84 "84 hours", add
label define hrsworklbl 85 "85 hours", add
label define hrsworklbl 86 "86 hours", add
label define hrsworklbl 87 "87 hours", add
label define hrsworklbl 88 "88 hours", add
label define hrsworklbl 89 "89 hours", add
label define hrsworklbl 90 "90 hours", add
label define hrsworklbl 91 "91 hours", add
label define hrsworklbl 92 "92 hours", add
label define hrsworklbl 93 "93 hours", add
label define hrsworklbl 94 "94 hours", add
label define hrsworklbl 95 "95 hours", add
label define hrsworklbl 96 "96 hours", add
label define hrsworklbl 97 "97 hours", add
label define hrsworklbl 98 "98 hours", add
label define hrsworklbl 99 "99 hours", add
label values hrswork hrsworklbl

label define uhrsworklbl 00 "NIU"
label define uhrsworklbl 01 "1 hour", add
label define uhrsworklbl 02 "2 hours", add
label define uhrsworklbl 03 "3 hours", add
label define uhrsworklbl 04 "4 hours", add
label define uhrsworklbl 05 "5 hours", add
label define uhrsworklbl 06 "6 hours", add
label define uhrsworklbl 07 "7 hours", add
label define uhrsworklbl 08 "8 hours", add
label define uhrsworklbl 09 "9 hours", add
label define uhrsworklbl 10 "10 hours", add
label define uhrsworklbl 11 "11 hours", add
label define uhrsworklbl 12 "12 hours", add
label define uhrsworklbl 13 "13 hours", add
label define uhrsworklbl 14 "14 hours", add
label define uhrsworklbl 15 "15 hours", add
label define uhrsworklbl 16 "16 hours", add
label define uhrsworklbl 17 "17 hours", add
label define uhrsworklbl 18 "18 hours", add
label define uhrsworklbl 19 "19 hours", add
label define uhrsworklbl 20 "20 hours", add
label define uhrsworklbl 21 "21 hours", add
label define uhrsworklbl 22 "22 hours", add
label define uhrsworklbl 23 "23 hours", add
label define uhrsworklbl 24 "24 hours", add
label define uhrsworklbl 25 "25 hours", add
label define uhrsworklbl 26 "26 hours", add
label define uhrsworklbl 27 "27 hours", add
label define uhrsworklbl 28 "28 hours", add
label define uhrsworklbl 29 "29 hours", add
label define uhrsworklbl 30 "30 hours", add
label define uhrsworklbl 31 "31 hours", add
label define uhrsworklbl 32 "32 hours", add
label define uhrsworklbl 33 "33 hours", add
label define uhrsworklbl 34 "34 hours", add
label define uhrsworklbl 35 "35 hours", add
label define uhrsworklbl 36 "36 hours", add
label define uhrsworklbl 37 "37 hours", add
label define uhrsworklbl 38 "38 hours", add
label define uhrsworklbl 39 "39 hours", add
label define uhrsworklbl 40 "40 hours", add
label define uhrsworklbl 41 "41 hours", add
label define uhrsworklbl 42 "42 hours", add
label define uhrsworklbl 43 "43 hours", add
label define uhrsworklbl 44 "44 hours", add
label define uhrsworklbl 45 "45 hours", add
label define uhrsworklbl 46 "46 hours", add
label define uhrsworklbl 47 "47 hours", add
label define uhrsworklbl 48 "48 hours", add
label define uhrsworklbl 49 "49 hours", add
label define uhrsworklbl 50 "50 hours", add
label define uhrsworklbl 51 "51 hours", add
label define uhrsworklbl 52 "52 hours", add
label define uhrsworklbl 53 "53 hours", add
label define uhrsworklbl 54 "54 hours", add
label define uhrsworklbl 55 "55 hours", add
label define uhrsworklbl 56 "56 hours", add
label define uhrsworklbl 57 "57 hours", add
label define uhrsworklbl 58 "58 hours", add
label define uhrsworklbl 59 "59 hours", add
label define uhrsworklbl 60 "60 hours", add
label define uhrsworklbl 61 "61 hours", add
label define uhrsworklbl 62 "62 hours", add
label define uhrsworklbl 63 "63 hours", add
label define uhrsworklbl 64 "64 hours", add
label define uhrsworklbl 65 "65 hours", add
label define uhrsworklbl 66 "66 hours", add
label define uhrsworklbl 67 "67 hours", add
label define uhrsworklbl 68 "68 hours", add
label define uhrsworklbl 69 "69 hours", add
label define uhrsworklbl 70 "70 hours", add
label define uhrsworklbl 71 "71 hours", add
label define uhrsworklbl 72 "72 hours", add
label define uhrsworklbl 73 "73 hours", add
label define uhrsworklbl 74 "74 hours", add
label define uhrsworklbl 75 "75 hours", add
label define uhrsworklbl 76 "76 hours", add
label define uhrsworklbl 77 "77 hours", add
label define uhrsworklbl 78 "78 hours", add
label define uhrsworklbl 79 "79 hours", add
label define uhrsworklbl 80 "80 hours", add
label define uhrsworklbl 81 "81 hours", add
label define uhrsworklbl 82 "82 hours", add
label define uhrsworklbl 83 "83 hours", add
label define uhrsworklbl 84 "84 hours", add
label define uhrsworklbl 85 "85 hours", add
label define uhrsworklbl 86 "86 hours", add
label define uhrsworklbl 87 "87 hours", add
label define uhrsworklbl 88 "88 hours", add
label define uhrsworklbl 89 "89 hours", add
label define uhrsworklbl 90 "90 hours", add
label define uhrsworklbl 91 "91 hours", add
label define uhrsworklbl 92 "92 hours", add
label define uhrsworklbl 93 "93 hours", add
label define uhrsworklbl 94 "94 hours", add
label define uhrsworklbl 95 "95 hours", add
label define uhrsworklbl 96 "96 hours", add
label define uhrsworklbl 97 "97 hours", add
label define uhrsworklbl 98 "98 hours", add
label define uhrsworklbl 99 "99 hours plus", add
label values uhrswork uhrsworklbl

label values incwage incwagelbl

label values earnweek earnweeklbl

label values adjginc adjginclbl

keep if mish==4 | mish==8

gen child18=.
for num 1/18: bysort serial year: egen temp1=count(pernum) if (momloc==X | poploc==X) & age<=18 \ bysort serial year: egen temp2=max(temp1) \ replace child18=temp2 if pernum==X \ drop temp*
recode child18 .=0

list child18 nchild eldch in 1/50

drop momloc stepmom momrule poploc steppop poprule sploc sprule nchild eldch yngch 

save marchmorgA, replace
